Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	15447
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.5 MiB
Average record size in memory	104.0 B

Variable types

Categorical	1
Numeric	12

Warnings

`Unnamed: 0` has a high cardinality: 15447 distinct values	High cardinality
`C42_1` is highly correlated with `C42_2` and 10 other fields	High correlation
`C42_2` is highly correlated with `C42_1` and 9 other fields	High correlation
`C42_3` is highly correlated with `C42_1` and 9 other fields	High correlation
`C42B_1` is highly correlated with `C42_1` and 9 other fields	High correlation
`C42B_2` is highly correlated with `C42_1` and 10 other fields	High correlation
`C42B_3` is highly correlated with `C42_1` and 9 other fields	High correlation
`LNCAP_1` is highly correlated with `C42_1` and 10 other fields	High correlation
`LNCAP_2` is highly correlated with `C42_1` and 9 other fields	High correlation
`LNCAP_3` is highly correlated with `C42_1` and 3 other fields	High correlation
`MR49F_1` is highly correlated with `C42_1` and 10 other fields	High correlation
`MR49F_2` is highly correlated with `C42_1` and 9 other fields	High correlation
`MR49F_3` is highly correlated with `C42_1` and 9 other fields	High correlation
`C42_1` is highly correlated with `C42_2` and 10 other fields	High correlation
`C42_2` is highly correlated with `C42_1` and 9 other fields	High correlation
`C42_3` is highly correlated with `C42_1` and 9 other fields	High correlation
`C42B_1` is highly correlated with `C42_1` and 9 other fields	High correlation
`C42B_2` is highly correlated with `C42_1` and 10 other fields	High correlation
`C42B_3` is highly correlated with `C42_1` and 9 other fields	High correlation
`LNCAP_1` is highly correlated with `C42_1` and 10 other fields	High correlation
`LNCAP_2` is highly correlated with `C42_1` and 9 other fields	High correlation
`LNCAP_3` is highly correlated with `C42_1` and 3 other fields	High correlation
`MR49F_1` is highly correlated with `C42_1` and 10 other fields	High correlation
`MR49F_2` is highly correlated with `C42_1` and 9 other fields	High correlation
`MR49F_3` is highly correlated with `C42_1` and 9 other fields	High correlation
`C42_1` is highly correlated with `C42_2` and 8 other fields	High correlation
`C42_2` is highly correlated with `C42_1`	High correlation
`C42_3` is highly correlated with `C42_1`	High correlation
`C42B_1` is highly correlated with `LNCAP_2`	High correlation
`C42B_2` is highly correlated with `C42_1`	High correlation
`C42B_3` is highly correlated with `C42_1` and 2 other fields	High correlation
`LNCAP_1` is highly correlated with `C42_1` and 2 other fields	High correlation
`LNCAP_2` is highly correlated with `C42_1` and 3 other fields	High correlation
`MR49F_1` is highly correlated with `C42_1` and 4 other fields	High correlation
`MR49F_2` is highly correlated with `C42_1` and 2 other fields	High correlation
`MR49F_3` is highly correlated with `C42_1` and 4 other fields	High correlation
`C42B_2` is highly correlated with `C42B_1` and 10 other fields	High correlation
`C42B_1` is highly correlated with `C42B_2` and 9 other fields	High correlation
`MR49F_3` is highly correlated with `C42B_2` and 9 other fields	High correlation
`C42_1` is highly correlated with `C42B_2` and 10 other fields	High correlation
`MR49F_2` is highly correlated with `C42B_2` and 10 other fields	High correlation
`LNCAP_2` is highly correlated with `C42B_2` and 10 other fields	High correlation
`LNCAP_1` is highly correlated with `C42B_2` and 10 other fields	High correlation
`LNCAP_3` is highly correlated with `C42B_2` and 8 other fields	High correlation
`C42B_3` is highly correlated with `C42B_2` and 10 other fields	High correlation
`C42_3` is highly correlated with `C42B_2` and 10 other fields	High correlation
`MR49F_1` is highly correlated with `C42B_2` and 10 other fields	High correlation
`C42_2` is highly correlated with `C42B_2` and 10 other fields	High correlation
`Unnamed: 0` is uniformly distributed	Uniform
`Unnamed: 0` has unique values	Unique
`C42_2` has 155 (1.0%) zeros	Zeros
`C42_3` has 172 (1.1%) zeros	Zeros
`LNCAP_1` has 241 (1.6%) zeros	Zeros
`LNCAP_2` has 262 (1.7%) zeros	Zeros
`LNCAP_3` has 288 (1.9%) zeros	Zeros
`MR49F_1` has 277 (1.8%) zeros	Zeros
`MR49F_2` has 308 (2.0%) zeros	Zeros
`MR49F_3` has 320 (2.1%) zeros	Zeros

Reproduction

Analysis started	2021-09-03 02:26:21.811386
Analysis finished	2021-09-03 02:27:03.007992
Duration	41.2 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

Unnamed: 0
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	15447
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	120.8 KiB

ENSG00000000003	1
ENSG00000179833	1
ENSG00000180104	1
ENSG00000180155	1
ENSG00000180178	1
Other values (15442)	15442

Length

Max length	15
Median length	15
Mean length	15
Min length	15

Characters and Unicode

Total characters	231705
Distinct characters	14
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	15447 ?
Unique (%)	100.0%

Sample

1st row	ENSG00000000003
2nd row	ENSG00000000419
3rd row	ENSG00000000457
4th row	ENSG00000000460
5th row	ENSG00000001036

Common Values

Value	Count	Frequency (%)
ENSG00000000003	1	< 0.1%
ENSG00000179833	1	< 0.1%
ENSG00000180104	1	< 0.1%
ENSG00000180155	1	< 0.1%
ENSG00000180178	1	< 0.1%
ENSG00000180182	1	< 0.1%
ENSG00000180185	1	< 0.1%
ENSG00000180190	1	< 0.1%
ENSG00000180198	1	< 0.1%
ENSG00000180211	1	< 0.1%
Other values (15437)	15437	99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ensg00000000003	1	< 0.1%
ensg00000179833	1	< 0.1%
ensg00000180104	1	< 0.1%
ensg00000180155	1	< 0.1%
ensg00000180178	1	< 0.1%
ensg00000180182	1	< 0.1%
ensg00000180185	1	< 0.1%
ensg00000180190	1	< 0.1%
ensg00000180198	1	< 0.1%
ensg00000180211	1	< 0.1%
Other values (15437)	15437	99.9%

Most occurring characters

Value	Count	Frequency (%)
0	86811	37.5%
1	17679	7.6%
E	15447	6.7%
N	15447	6.7%
S	15447	6.7%
G	15447	6.7%
2	10870	4.7%
6	8508	3.7%
3	8143	3.5%
7	8058	3.5%
Other values (4)	29848	12.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	169917	73.3%
Uppercase Letter	61788	26.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	86811	51.1%
1	17679	10.4%
2	10870	6.4%
6	8508	5.0%
3	8143	4.8%
7	8058	4.7%
4	7836	4.6%
5	7633	4.5%
8	7623	4.5%
9	6756	4.0%

Uppercase Letter

Value	Count	Frequency (%)
E	15447	25.0%
N	15447	25.0%
S	15447	25.0%
G	15447	25.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	169917	73.3%
Latin	61788	26.7%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	86811	51.1%
1	17679	10.4%
2	10870	6.4%
6	8508	5.0%
3	8143	4.8%
7	8058	4.7%
4	7836	4.6%
5	7633	4.5%
8	7623	4.5%
9	6756	4.0%

Latin

Value	Count	Frequency (%)
E	15447	25.0%
N	15447	25.0%
S	15447	25.0%
G	15447	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	231705	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	86811	37.5%
1	17679	7.6%
E	15447	6.7%
N	15447	6.7%
S	15447	6.7%
G	15447	6.7%
2	10870	4.7%
6	8508	3.7%
3	8143	3.5%
7	8058	3.5%
Other values (4)	29848	12.9%

C42_1
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	15369
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.951898787

Minimum	0
Maximum	7.892393394
Zeros	61
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	120.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0.1610274862
Q1	0.8498795217
median	1.862615638
Q3	2.83823344
95-th percentile	4.23297546
Maximum	7.892393394
Range	7.892393394
Interquartile range (IQR)	1.988353918

Descriptive statistics

Standard deviation	1.300086919
Coefficient of variation (CV)	0.6660626705
Kurtosis	-0.1677060908
Mean	1.951898787
Median Absolute Deviation (MAD)	0.9978378567
Skewness	0.5317600109
Sum	30150.98057
Variance	1.690225997
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	61	0.4%
0.6659404101	2	< 0.1%
1.281846484	2	< 0.1%
1.41680996	2	< 0.1%
4.028434077	2	< 0.1%
0.898886147	2	< 0.1%
0.3026337618	2	< 0.1%
3.227263158	2	< 0.1%
0.9008038264	2	< 0.1%
2.401638097	2	< 0.1%
Other values (15359)	15368	99.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	61	0.4%
0.0005085017078	1	< 0.1%
0.001573013268	1	< 0.1%
0.001597793225	1	< 0.1%
0.00187396004	1	< 0.1%
0.002140721668	1	< 0.1%
0.002330904331	1	< 0.1%
0.002956522178	1	< 0.1%
0.00298667245	1	< 0.1%
0.003138292721	1	< 0.1%

Value	Count	Frequency (%)
7.892393394	1	< 0.1%
7.831987593	1	< 0.1%
7.619986692	1	< 0.1%
7.39250219	1	< 0.1%
7.379677691	1	< 0.1%
7.273229297	1	< 0.1%
7.014293101	1	< 0.1%
6.998174898	1	< 0.1%
6.904018807	1	< 0.1%
6.851251485	1	< 0.1%

C42_2
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	14653
Distinct (%)	94.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.552723153

Minimum	0
Maximum	10.43157052
Zeros	155
Zeros (%)	1.0%
Negative	0
Negative (%)	0.0%
Memory size	120.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0.5061604513
Q1	1.95704364
median	3.406321311
Q3	5.024928624
95-th percentile	6.996169952
Maximum	10.43157052
Range	10.43157052
Interquartile range (IQR)	3.067884984

Descriptive statistics

Standard deviation	2.012930941
Coefficient of variation (CV)	0.5665881789
Kurtosis	-0.6951380179
Mean	3.552723153
Median Absolute Deviation (MAD)	1.519974044
Skewness	0.2834276573
Sum	54878.91454
Variance	4.051890974
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	155	1.0%
4.84681738	7	< 0.1%
2.719211263	6	< 0.1%
2.453266785	5	< 0.1%
3.268309492	5	< 0.1%
5.94018036	5	< 0.1%
1.744455498	4	< 0.1%
2.820891319	4	< 0.1%
1.948182986	4	< 0.1%
4.269078679	4	< 0.1%
Other values (14643)	15248	98.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	155	1.0%
0.009036109119	1	< 0.1%
0.009541831548	1	< 0.1%
0.009968741891	1	< 0.1%
0.01064671328	1	< 0.1%
0.01781371243	1	< 0.1%
0.02013955092	1	< 0.1%
0.02052400116	1	< 0.1%
0.02084745477	1	< 0.1%
0.02317246263	1	< 0.1%

Value	Count	Frequency (%)
10.43157052	1	< 0.1%
10.349653	1	< 0.1%
10.2821719	1	< 0.1%
9.940916369	1	< 0.1%
9.730690691	1	< 0.1%
9.719821334	1	< 0.1%
9.718746011	1	< 0.1%
9.7022889	1	< 0.1%
9.571722906	1	< 0.1%
9.526740359	1	< 0.1%

C42_3
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	14692
Distinct (%)	95.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.539029987

Minimum	0
Maximum	10.3760024
Zeros	172
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	120.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0.6003213661
Q1	2.11978603
median	3.592985744
Q3	4.869818591
95-th percentile	6.45859939
Maximum	10.3760024
Range	10.3760024
Interquartile range (IQR)	2.750032561

Descriptive statistics

Standard deviation	1.809643457
Coefficient of variation (CV)	0.511338831
Kurtosis	-0.6145670019
Mean	3.539029987
Median Absolute Deviation (MAD)	1.366996069
Skewness	0.07097125064
Sum	54667.39621
Variance	3.27480944
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	172	1.1%
4.951359849	8	0.1%
3.047016408	5	< 0.1%
2.920247872	5	< 0.1%
1.793942086	5	< 0.1%
5.640963868	5	< 0.1%
2.710494353	5	< 0.1%
2.039159245	4	< 0.1%
3.047016468	4	< 0.1%
3.471739174	4	< 0.1%
Other values (14682)	15230	98.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	172	1.1%
0.01417417143	1	< 0.1%
0.02240524036	1	< 0.1%
0.02541092692	1	< 0.1%
0.03615135364	1	< 0.1%
0.04004178112	1	< 0.1%
0.0442984835	1	< 0.1%
0.04670126966	1	< 0.1%
0.04781506987	1	< 0.1%
0.04832547946	1	< 0.1%

Value	Count	Frequency (%)
10.3760024	1	< 0.1%
10.1329809	1	< 0.1%
9.970519953	1	< 0.1%
9.86549563	1	< 0.1%
9.793920572	1	< 0.1%
9.513450813	1	< 0.1%
9.484807257	1	< 0.1%
9.452753922	1	< 0.1%
9.385801861	1	< 0.1%
9.253838972	1	< 0.1%

C42B_1
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	14928
Distinct (%)	96.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.370020893

Minimum	0
Maximum	10.3141713
Zeros	145
Zeros (%)	0.9%
Negative	0
Negative (%)	0.0%
Memory size	120.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0.2221046035
Q1	1.585332705
median	3.505783856
Q3	4.935459095
95-th percentile	6.650378693
Maximum	10.3141713
Range	10.3141713
Interquartile range (IQR)	3.35012639

Descriptive statistics

Standard deviation	2.059899841
Coefficient of variation (CV)	0.611242454
Kurtosis	-0.8741049554
Mean	3.370020893
Median Absolute Deviation (MAD)	1.630820221
Skewness	0.07756979364
Sum	52056.71274
Variance	4.243187354
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	145	0.9%
4.756895742	9	0.1%
5.849763402	9	0.1%
4.072304099	6	< 0.1%
5.445737548	6	< 0.1%
2.735860537	5	< 0.1%
3.525385919	5	< 0.1%
2.931268239	5	< 0.1%
3.675321952	4	< 0.1%
2.223728003	4	< 0.1%
Other values (14918)	15249	98.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	145	0.9%
0.006979174803	1	< 0.1%
0.007399915962	1	< 0.1%
0.01056767491	1	< 0.1%
0.01074380805	1	< 0.1%
0.01146322545	1	< 0.1%
0.01382911546	1	< 0.1%
0.01411502271	1	< 0.1%
0.01452550224	1	< 0.1%
0.01494699503	1	< 0.1%

Value	Count	Frequency (%)
10.3141713	1	< 0.1%
10.17330579	1	< 0.1%
10.05881009	1	< 0.1%
9.995840637	1	< 0.1%
9.90117174	1	< 0.1%
9.558978197	1	< 0.1%
9.482184806	1	< 0.1%
9.469922056	1	< 0.1%
9.315657587	1	< 0.1%
9.31475654	1	< 0.1%

C42B_2
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	15135
Distinct (%)	98.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.150177325

Minimum	0
Maximum	9.07493053
Zeros	151
Zeros (%)	1.0%
Negative	0
Negative (%)	0.0%
Memory size	120.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0.1886488344
Q1	1.031215756
median	2.083637162
Q3	3.070509477
95-th percentile	4.499787722
Maximum	9.07493053
Range	9.07493053
Interquartile range (IQR)	2.039293721

Descriptive statistics

Standard deviation	1.361662853
Coefficient of variation (CV)	0.6332793286
Kurtosis	-0.05635037148
Mean	2.150177325
Median Absolute Deviation (MAD)	1.015766542
Skewness	0.4862304588
Sum	33213.78914
Variance	1.854125725
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	151	1.0%
3.289982727	8	0.1%
2.968302493	6	< 0.1%
2.815328477	4	< 0.1%
2.517781953	3	< 0.1%
3.785794482	3	< 0.1%
3.057229456	3	< 0.1%
1.696640221	3	< 0.1%
3.074103893	3	< 0.1%
2.27181274	3	< 0.1%
Other values (15125)	15260	98.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	151	1.0%
0.006988010879	1	< 0.1%
0.009263502393	1	< 0.1%
0.009769915182	1	< 0.1%
0.01039894308	1	< 0.1%
0.01046887514	1	< 0.1%
0.01083131197	1	< 0.1%
0.0109925694	1	< 0.1%
0.01223080461	1	< 0.1%
0.01345894075	1	< 0.1%

Value	Count	Frequency (%)
9.07493053	1	< 0.1%
8.340517109	1	< 0.1%
8.211243681	1	< 0.1%
8.110590637	1	< 0.1%
8.047052273	1	< 0.1%
7.959441161	1	< 0.1%
7.658533428	1	< 0.1%
7.647999286	1	< 0.1%
7.632476646	1	< 0.1%
7.587102821	1	< 0.1%

C42B_3
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	14709
Distinct (%)	95.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.688297728

Minimum	0
Maximum	12.08922249
Zeros	145
Zeros (%)	0.9%
Negative	0
Negative (%)	0.0%
Memory size	120.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0.6114117762
Q1	2.118754437
median	3.684648275
Q3	5.122908431
95-th percentile	6.9340729
Maximum	12.08922249
Range	12.08922249
Interquartile range (IQR)	3.004153993

Descriptive statistics

Standard deviation	1.959593808
Coefficient of variation (CV)	0.5313003321
Kurtosis	-0.7047934925
Mean	3.688297728
Median Absolute Deviation (MAD)	1.509203776
Skewness	0.1492733792
Sum	56973.13501
Variance	3.840007892
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	145	0.9%
4.043960743	8	0.1%
4.728305339	7	< 0.1%
2.652444027	6	< 0.1%
3.222750823	5	< 0.1%
4.327251209	5	< 0.1%
3.153622188	5	< 0.1%
3.368189632	5	< 0.1%
5.639277085	5	< 0.1%
1.846606334	4	< 0.1%
Other values (14699)	15252	98.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	145	0.9%
0.008985573548	1	< 0.1%
0.009189608956	1	< 0.1%
0.01481302972	1	< 0.1%
0.01707364683	1	< 0.1%
0.02420292409	1	< 0.1%
0.02563067004	1	< 0.1%
0.02926395452	1	< 0.1%
0.02951048069	1	< 0.1%
0.02953121679	1	< 0.1%

Value	Count	Frequency (%)
12.08922249	1	< 0.1%
11.22250364	1	< 0.1%
10.27650155	1	< 0.1%
10.14907672	1	< 0.1%
9.909951465	1	< 0.1%
9.689277726	1	< 0.1%
9.684131084	1	< 0.1%
9.580388988	1	< 0.1%
9.478856742	1	< 0.1%
9.416888711	1	< 0.1%

LNCAP_1
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	14741
Distinct (%)	95.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.604673585

Minimum	0
Maximum	10.71102758
Zeros	241
Zeros (%)	1.6%
Negative	0
Negative (%)	0.0%
Memory size	120.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0.457849735
Q1	2.205752864
median	3.691843215
Q3	4.963779829
95-th percentile	6.56451032
Maximum	10.71102758
Range	10.71102758
Interquartile range (IQR)	2.758026965

Descriptive statistics

Standard deviation	1.864446435
Coefficient of variation (CV)	0.5172303098
Kurtosis	-0.5852331016
Mean	3.604673585
Median Absolute Deviation (MAD)	1.366280369
Skewness	0.01355618853
Sum	55681.39286
Variance	3.47616051
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	241	1.6%
3.64156119	7	< 0.1%
3.148058862	6	< 0.1%
2.192882274	5	< 0.1%
1.8417134	5	< 0.1%
5.81521104	4	< 0.1%
3.641561144	4	< 0.1%
3.49176956	4	< 0.1%
2.1318288	4	< 0.1%
1.028778368	4	< 0.1%
Other values (14731)	15163	98.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	241	1.6%
0.007206084693	1	< 0.1%
0.01167227006	1	< 0.1%
0.01385279543	1	< 0.1%
0.01488915437	1	< 0.1%
0.01542919131	1	< 0.1%
0.01743631421	1	< 0.1%
0.01839614128	1	< 0.1%
0.02162675646	1	< 0.1%
0.02188581869	1	< 0.1%

Value	Count	Frequency (%)
10.71102758	1	< 0.1%
10.01173272	1	< 0.1%
9.897880524	1	< 0.1%
9.813341814	1	< 0.1%
9.740835673	1	< 0.1%
9.627622375	1	< 0.1%
9.56518686	1	< 0.1%
9.288912152	1	< 0.1%
9.207373282	1	< 0.1%
9.202634008	1	< 0.1%

LNCAP_2
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	14898
Distinct (%)	96.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.970001739

Minimum	0
Maximum	11.0673857
Zeros	262
Zeros (%)	1.7%
Negative	0
Negative (%)	0.0%
Memory size	120.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0.1440552365
Q1	1.090400324
median	2.83238737
Q3	4.57855383
95-th percentile	6.52172794
Maximum	11.0673857
Range	11.0673857
Interquartile range (IQR)	3.488153506

Descriptive statistics

Standard deviation	2.069878367
Coefficient of variation (CV)	0.6969283349
Kurtosis	-0.8115342857
Mean	2.970001739
Median Absolute Deviation (MAD)	1.742738052
Skewness	0.3505866418
Sum	45877.61687
Variance	4.284396454
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	262	1.7%
4.770472067	6	< 0.1%
3.409288898	5	< 0.1%
2.692039742	5	< 0.1%
2.235948532	5	< 0.1%
4.589844351	4	< 0.1%
5.863417411	4	< 0.1%
5.29760394	3	< 0.1%
4.553492197	3	< 0.1%
1.550428516	3	< 0.1%
Other values (14888)	15147	98.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	262	1.7%
0.005919354999	1	< 0.1%
0.006726786356	1	< 0.1%
0.01010286674	1	< 0.1%
0.01064532691	1	< 0.1%
0.01130916126	1	< 0.1%
0.01149136522	1	< 0.1%
0.01204267109	1	< 0.1%
0.01239617891	1	< 0.1%
0.01287935391	1	< 0.1%

Value	Count	Frequency (%)
11.0673857	1	< 0.1%
9.872289148	1	< 0.1%
9.775393027	1	< 0.1%
9.676171606	1	< 0.1%
9.38514718	1	< 0.1%
9.338703911	1	< 0.1%
9.287739335	1	< 0.1%
9.258570379	1	< 0.1%
9.148122949	1	< 0.1%
9.092171134	1	< 0.1%

LNCAP_3
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	14344
Distinct (%)	92.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.573745194

Minimum	0
Maximum	12.00651744
Zeros	288
Zeros (%)	1.9%
Negative	0
Negative (%)	0.0%
Memory size	120.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0.1510752765
Q1	1.42177245
median	2.537786457
Q3	3.554847892
95-th percentile	5.324498014
Maximum	12.00651744
Range	12.00651744
Interquartile range (IQR)	2.133075442

Descriptive statistics

Standard deviation	1.570222596
Coefficient of variation (CV)	0.610092483
Kurtosis	0.2561218642
Mean	2.573745194
Median Absolute Deviation (MAD)	1.066457613
Skewness	0.4874070141
Sum	39756.64201
Variance	2.465599001
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	288	1.9%
2.983261334	13	0.1%
2.939954201	12	0.1%
2.666837853	12	0.1%
3.048873435	11	0.1%
2.913040101	10	0.1%
2.755812536	10	0.1%
2.339501615	10	0.1%
3.606311644	10	0.1%
2.613436912	9	0.1%
Other values (14334)	15062	97.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	288	1.9%
0.003881522137	1	< 0.1%
0.009352914789	1	< 0.1%
0.009761905645	1	< 0.1%
0.01032077647	1	< 0.1%
0.01035358246	1	< 0.1%
0.01039790105	1	< 0.1%
0.01082269281	1	< 0.1%
0.01095338163	1	< 0.1%
0.01124560028	1	< 0.1%

Value	Count	Frequency (%)
12.00651744	1	< 0.1%
10.59512009	1	< 0.1%
10.06855782	1	< 0.1%
9.675603407	1	< 0.1%
9.674318384	1	< 0.1%
9.619842653	1	< 0.1%
9.385773256	1	< 0.1%
8.894539444	1	< 0.1%
8.738322235	1	< 0.1%
8.641724782	1	< 0.1%

MR49F_1
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	14677
Distinct (%)	95.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.458925762

Minimum	0
Maximum	11.92862799
Zeros	277
Zeros (%)	1.8%
Negative	0
Negative (%)	0.0%
Memory size	120.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0.3672982593
Q1	2.01226665
median	3.544871663
Q3	4.795379487
95-th percentile	6.480920216
Maximum	11.92862799
Range	11.92862799
Interquartile range (IQR)	2.783112837

Descriptive statistics

Standard deviation	1.864869199
Coefficient of variation (CV)	0.5391469282
Kurtosis	-0.5512277302
Mean	3.458925762
Median Absolute Deviation (MAD)	1.389315832
Skewness	0.09543331641
Sum	53430.02624
Variance	3.47773713
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	277	1.8%
3.600424771	7	< 0.1%
2.589855831	6	< 0.1%
3.321805546	6	< 0.1%
1.60081827	5	< 0.1%
4.680661174	5	< 0.1%
1.730819089	4	< 0.1%
3.568544938	4	< 0.1%
2.788895663	4	< 0.1%
2.292882777	4	< 0.1%
Other values (14667)	15125	97.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	277	1.8%
0.003743514394	1	< 0.1%
0.01674873361	1	< 0.1%
0.01696091079	1	< 0.1%
0.01727911258	1	< 0.1%
0.01993962348	1	< 0.1%
0.02201904466	1	< 0.1%
0.02237411427	1	< 0.1%
0.02240695857	1	< 0.1%
0.0234564656	1	< 0.1%

Value	Count	Frequency (%)
11.92862799	1	< 0.1%
10.75541009	1	< 0.1%
10.31202863	1	< 0.1%
9.944640532	1	< 0.1%
9.827391496	1	< 0.1%
9.777935431	1	< 0.1%
9.769815757	1	< 0.1%
9.700536161	1	< 0.1%
9.642118925	1	< 0.1%
9.628545974	1	< 0.1%

MR49F_2
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	14579
Distinct (%)	94.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.505392333

Minimum	0
Maximum	10.39896276
Zeros	308
Zeros (%)	2.0%
Negative	0
Negative (%)	0.0%
Memory size	120.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0.3856645838
Q1	2.008680044
median	3.571742366
Q3	4.907524339
95-th percentile	6.643014171
Maximum	10.39896276
Range	10.39896276
Interquartile range (IQR)	2.898844295

Descriptive statistics

Standard deviation	1.912064336
Coefficient of variation (CV)	0.5454637184
Kurtosis	-0.6707650258
Mean	3.505392333
Median Absolute Deviation (MAD)	1.443700972
Skewness	0.08612470762
Sum	54147.79536
Variance	3.655990026
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	308	2.0%
4.082015953	6	< 0.1%
4.766690635	6	< 0.1%
6.14658318	5	< 0.1%
2.635317488	5	< 0.1%
0.9983023308	5	< 0.1%
1.402799822	5	< 0.1%
3.016593565	5	< 0.1%
1.027031786	5	< 0.1%
4.481840712	5	< 0.1%
Other values (14569)	15092	97.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	308	2.0%
0.01559944861	1	< 0.1%
0.01630217452	1	< 0.1%
0.01756262035	1	< 0.1%
0.02067938339	1	< 0.1%
0.02239642301	1	< 0.1%
0.0228666937	1	< 0.1%
0.02320365098	1	< 0.1%
0.02333141586	1	< 0.1%
0.02422135352	1	< 0.1%

Value	Count	Frequency (%)
10.39896276	1	< 0.1%
10.10495384	1	< 0.1%
9.935755319	1	< 0.1%
9.918437247	1	< 0.1%
9.864378545	1	< 0.1%
9.848159815	1	< 0.1%
9.84495708	1	< 0.1%
9.709074791	1	< 0.1%
9.707342973	1	< 0.1%
9.703140305	1	< 0.1%

MR49F_3
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	14957
Distinct (%)	96.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.605250162

Minimum	0
Maximum	10.6228612
Zeros	320
Zeros (%)	2.1%
Negative	0
Negative (%)	0.0%
Memory size	120.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0.09483151545
Q1	0.8508791566
median	2.329808257
Q3	3.939173166
95-th percentile	6.369273736
Maximum	10.6228612
Range	10.6228612
Interquartile range (IQR)	3.08829401

Descriptive statistics

Standard deviation	1.993926657
Coefficient of variation (CV)	0.7653494032
Kurtosis	-0.3322920922
Mean	2.605250162
Median Absolute Deviation (MAD)	1.529473531
Skewness	0.6420145042
Sum	40243.29926
Variance	3.975743514
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	320	2.1%
0.3008276643	5	< 0.1%
3.155403234	4	< 0.1%
4.730149314	4	< 0.1%
4.045788573	3	< 0.1%
2.138594338	3	< 0.1%
1.809126574	3	< 0.1%
0.8698587937	3	< 0.1%
2.503993991	3	< 0.1%
1.963769052	3	< 0.1%
Other values (14947)	15096	97.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	320	2.1%
0.004746110107	1	< 0.1%
0.005767274256	1	< 0.1%
0.006465480476	1	< 0.1%
0.007517525747	1	< 0.1%
0.007713194972	1	< 0.1%
0.008546672902	1	< 0.1%
0.009521180157	1	< 0.1%
0.009727337675	1	< 0.1%
0.01033988863	1	< 0.1%

Value	Count	Frequency (%)
10.6228612	1	< 0.1%
9.509793808	1	< 0.1%
9.409200849	1	< 0.1%
9.316749364	1	< 0.1%
9.294765299	1	< 0.1%
9.22522545	1	< 0.1%
9.19727908	1	< 0.1%
9.196983673	1	< 0.1%
9.181939273	1	< 0.1%
9.181910374	1	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	Unnamed: 0	C42_1	C42_2	C42_3	C42B_1	C42B_2	C42B_3	LNCAP_1	LNCAP_2	LNCAP_3	MR49F_1	MR49F_2	MR49F_3
0	ENSG00000000003	2.020308	1.785015	2.324127	3.197007	2.064842	6.445762	3.295497	2.607519	2.222021	3.189540	4.894341	2.940336
1	ENSG00000000419	4.223350	4.713971	5.314652	4.487993	1.892768	6.312067	5.741332	4.732900	1.927913	5.283732	5.632829	4.111696
2	ENSG00000000457	2.869919	1.374323	2.927670	4.786854	1.636581	5.395142	3.223221	3.675430	1.599096	3.700928	4.173679	3.952226
3	ENSG00000000460	1.751904	3.726353	5.071506	2.202074	1.897405	5.428105	3.805228	4.056825	3.083022	3.577544	3.705059	3.998118
4	ENSG00000001036	3.481197	5.063655	6.182233	3.105899	3.810156	7.683152	4.768722	5.238380	3.119561	4.688014	4.726366	5.203400
5	ENSG00000001084	2.942330	2.333494	4.617713	5.635060	2.896378	6.775170	3.598248	2.852836	2.222317	4.563238	5.161199	4.686099
6	ENSG00000001167	2.236061	4.362950	4.712983	4.574876	4.161959	6.582590	4.672079	4.134103	3.883999	5.326048	4.432233	3.775862
7	ENSG00000001460	1.185808	0.558803	3.482216	1.233932	1.658788	4.182730	1.896393	3.536727	1.189241	2.766417	2.379161	2.201291
8	ENSG00000001461	2.176179	4.419352	3.642802	5.074364	3.150158	6.254512	5.182730	4.614492	2.279997	4.556380	4.541312	4.362653
9	ENSG00000001497	3.180836	3.807909	5.077788	3.610549	3.387535	6.877675	4.356536	3.714680	2.284986	5.966947	6.262935	5.303243

Last rows

	Unnamed: 0	C42_1	C42_2	C42_3	C42B_1	C42B_2	C42B_3	LNCAP_1	LNCAP_2	LNCAP_3	MR49F_1	MR49F_2	MR49F_3
15437	ENSG00000283486	0.478085	1.304107	1.318069	0.292569	2.246345	1.304303	0.000000	0.187186	2.808091	0.874059	1.254480	0.057845
15438	ENSG00000283491	0.372342	1.987290	1.074813	0.778366	3.479082	1.097908	2.456491	0.783938	2.097986	2.076424	0.990410	0.155038
15439	ENSG00000283498	0.412790	1.798533	1.283445	0.199129	3.151180	1.634624	1.162911	0.781655	4.114055	1.224394	1.837497	0.475062
15440	ENSG00000283511	0.441553	5.403062	1.472595	0.657973	2.740264	1.285139	0.067667	0.022542	1.753941	1.730819	1.025936	0.159346
15441	ENSG00000283526	1.976393	3.288785	3.569011	0.811898	4.416365	2.206559	3.343384	1.603189	1.798374	3.444252	3.157803	2.358798
15442	ENSG00000283577	0.000000	0.000000	0.000000	1.185395	3.038733	1.407959	0.000000	0.000000	0.000000	0.241026	0.443119	0.057711
15443	ENSG00000283633	0.000000	0.000000	0.000000	1.281448	3.862337	2.777843	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000
15444	ENSG00000283667	0.284246	0.589815	0.517013	0.281662	2.205606	0.199881	0.747785	0.097802	2.356567	1.511373	1.538255	1.308785
15445	ENSG00000283674	1.287284	1.500634	1.149604	2.112427	3.712065	2.068337	1.648880	0.904898	1.482742	1.492116	1.956922	0.306116
15446	ENSG00000283689	0.291608	0.577202	1.412319	0.643074	3.038733	1.646887	0.609168	0.500472	1.258260	1.004187	0.907208	0.402196

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows